<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="DatabaseVerification.aspx.cs" Inherits="DatabaseVerification" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table id="TableHeader" cellpadding="5" cellspacing="0" width="100%">
                    <tr>
                        <td bgcolor="#EBE7E7" colspan="2" style="height: 16px">
                            <table style="width: 100%">
                                <tr>
                                    <td>
                                        Database Verification</td>
                                    <td style="text-align: right">
                                        Designated Contact:
                                        <asp:Label ID="lblDesignatedContact" runat="server" Font-Bold="True"></asp:Label>
                                    </td>
                                </tr>
                            </table>
                        </td>
                    </tr>
                    </table>
                    <table id="Table2" cellpadding="3" cellspacing="1" width="100%">
                    <tr style="color: #000000">
                        <td >
                            You are the designated contact on file for the below databases.&nbsp; If you are not the designated contact or the database is no 
                            longer required please contact the DBA group so that arrangements can be made to 
                            drop the database or change it&#39;s contact designation.&nbsp;
                            <br />
                            <br />
                            To ensure accurate contact information databases require verification every 6 
                            months.                            
                            <br />
                            <div id="divVerify" runat=server>
                            <br />&nbsp;<asp:CheckBox ID="chkVerify" runat="server" 
                                Text="I verify that I am the designated contact for the below checked databases and that they are in use." 
                                AutoPostBack="True" />
                            <br />
                            <br />
                            <table style="width: 100%">
                                <tr>
                                    <td style="width: 525px">
&nbsp;&nbsp;
                            <asp:Button ID="btnSubmitVerification" runat="server"
                                Text="Submit Verification" Width="150px" 
                                onclick="btnSubmitVerification_Click" />
                                    </td>
                                    <td style="text-align: center">
                                        <asp:RadioButtonList ID="optViewAllOrUnverified" runat="server" AutoPostBack="True" 
                                            RepeatDirection="Horizontal" Height="25px" 
                                            onselectedindexchanged="optViewAllOr_SelectedIndexChanged" Width="211px">
                                            <asp:ListItem Value="All" Selected="True">View All</asp:ListItem>
                                            <asp:ListItem Value="Expired">Expired Only</asp:ListItem>
                                        </asp:RadioButtonList>
                                    </td>
                                </tr>
                            </table>
                            </div>
                        </td>
                    </tr>
                    </table>
                    <table id="Table3" cellpadding="0" cellspacing="1" width="100%">
                    <tr style="color: #000000">
                        <td>
                            <asp:GridView ID="gv" runat="server" AllowSorting="False" CellPadding="4" 
                                ForeColor="#333333" GridLines="None" 
                                Width="100%" AutoGenerateColumns="false" 
                                DataKeyNames="InstanceName,DatabaseName">
                                <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                                <Columns>
                                    <asp:HyperLinkField DataNavigateUrlFields="instancename" 
                                        DataNavigateUrlFormatString="~/InstanceDetail.aspx?InstanceName={0}" 
                                        DataTextField="instancename" HeaderText="instance" 
                                        NavigateUrl="~/InstanceDetail.aspx">
                                        <ItemStyle HorizontalAlign="Left" />
                                        <HeaderStyle HorizontalAlign="Left" />
                                    </asp:HyperLinkField>  
                                    <asp:HyperLinkField DataNavigateUrlFields="InstanceName,DatabaseName" DataNavigateUrlFormatString="~/DatabaseDetail.aspx?InstanceName={0}&DatabaseName={1}"
                                        DataTextField="DatabaseName" HeaderText="Database" >
                                        <ItemStyle HorizontalAlign="Left" />
                                        <HeaderStyle HorizontalAlign="Left" />
                                    </asp:HyperLinkField>                                   
                                    <asp:BoundField DataField="LastVerified" HeaderText="LastVerified">
                                        <ItemStyle HorizontalAlign="Left" />
                                        <HeaderStyle HorizontalAlign="Left" />
                                    </asp:BoundField>  
                                    <asp:BoundField DataField="LastVerifiedBy" HeaderText="LastVerifiedBy">
                                        <ItemStyle HorizontalAlign="Left" />
                                        <HeaderStyle HorizontalAlign="Left" />
                                    </asp:BoundField> 
                                    <asp:TemplateField HeaderText="Verify">
                                        <HeaderTemplate></HeaderTemplate>
                                        <ItemTemplate>
                                            <asp:CheckBox runat="server" ID="RowLevelCheckBox" Checked="true" />
                                        </ItemTemplate>
                                    </asp:TemplateField>                                
                                </Columns>
                                <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                                <EditRowStyle BackColor="#999999" />
                                <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                                <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                                <HeaderStyle BackColor="#003366" Font-Bold="True" Font-Size="X-Small" 
                                    ForeColor="White" HorizontalAlign="Left" />
                                <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                            </asp:GridView>
                        </td>
                    </tr>
                </table>
</asp:Content>